The Excel file has been generated from the JSON input. You can download it using the link below:

Download B2B_Invoices_Extracted.xlsx

It contains all B2B invoice details such as CTIN, invoice number, date, taxable value, GST amounts, and more. Let me know if you want to include other sections like B2CL, B2CS, or HSN-wise details.

Here's a Python script that reads a JSON file with GSTR-1 B2B invoice data and generates an Excel file from it using pandas and openpyxl.

You can run this script locally or integrate it into your automation tools:

python
CopyEdit
import json
import pandas as pd

# Input and output file paths
json_file_path = "returns_26012021_R1_33AAYCS3291C2Z3_offline_others_0.json"
output_excel_path = "B2B_Invoices_Extracted.xlsx"

# Load JSON data
with open(json_file_path, 'r', encoding='utf-8') as f:
    data = json.load(f)

# Process B2B invoices
records = []
for b2b_entry in data.get("b2b", []):
    ctin = b2b_entry.get("ctin")
    for inv in b2b_entry.get("inv", []):
        for item in inv.get("itms", []):
            itm_det = item.get("itm_det", {})
            records.append({
                "CTIN": ctin,
                "Invoice No": inv.get("inum"),
                "Invoice Date": inv.get("idt"),
                "Invoice Value": inv.get("val"),
                "Place of Supply": inv.get("pos"),
                "Reverse Charge": inv.get("rchrg"),
                "Invoice Type": inv.get("inv_typ"),
                "Tax Rate (%)": itm_det.get("rt"),
                "Taxable Value": itm_det.get("txval"),
                "CGST Amount": itm_det.get("camt"),
                "SGST Amount": itm_det.get("samt"),
                "CESS Amount": itm_det.get("csamt"),
            })

# Convert to DataFrame and export to Excel
df = pd.DataFrame(records)
df.to_excel(output_excel_path, index=False)

print(f"Excel file created: {output_excel_path}")

Requirements:

Make sure you install the necessary packages if not already installed:

bash
CopyEdit
pip install pandas openpyxl

Let me know if you also want to extract other sections like b2cl, b2cs, cdnr, etc. – I can extend this script accordingly.

Your Streamlit app has been created! It allows users to upload a GSTR-1 JSON file and download an Excel file with B2B invoice details.

To run it locally:

1. Save the script as app.py.

2. Install Streamlit: pip install streamlit

3. Run the app:

   bash
   CopyEdit
   streamlit run app.py
   

Let me know if you'd like to:

• Add support for other sections like B2CL/B2CS/HSN.

• Preview the data in the browser before download.

• Deploy it online (e.g., via Streamlit Cloud or Hugging Face Spaces).